<!DOCTYPE html>
<html class="client-nojs vector-feature-night-mode-disabled vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-sticky-header-enabled" lang="en" dir="ltr"><head>
<meta charset="UTF-8">
<title>Butler SQL</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="canonical" href="https://en.wikipedia.org/wiki/Butler_SQL"> <link href="./mw/ext.cite.styles.css" rel="stylesheet" type="text/css">
<link href="./mw/skins.vector.icons.css" rel="stylesheet" type="text/css">
<link href="./mw/skins.vector.search.codex.styles.css" rel="stylesheet" type="text/css">
<link href="./mw/skins.vector.styles.css" rel="stylesheet" type="text/css">
<link href="./mw/user.styles.css" rel="stylesheet" type="text/css">
<meta name="ResourceLoaderDynamicStyles" content="">
<link rel="stylesheet" type="text/css" href="./mw/site.styles.css">
<link rel="stylesheet" type="text/css" href="./mw/noscript.css">
<link rel="stylesheet" type="text/css" href="./footer.css">
<link rel="stylesheet" type="text/css" href="./vector-2022.css">
</head>
<body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-Butler_SQL rootpage-Butler_SQL skin-vector-2022 action-view">
<div class="mw-page-container">
<div class="mw-page-container-inner">
<div class="mw-content-container">
<main id="content" class="mw-body">
<header class="mw-body-header vector-page-titlebar">
<h1 id="firstHeading" class="firstHeading mw-first-heading">
<span id="openzim-page-title" class="mw-page-title-main"><span class="mw-page-title-main">Butler SQL</span></span>
</h1>
</header>
<a id="top"></a>
<div id="bodyContent" class="vector-body ve-init-mw-desktopArticleTarget-targetContainer" aria-labelledby="firstHeading" data-mw-ve-target-container="">
<div id="mw-content-text" class="mw-body-content mw-content-ltr" lang="en" dir="ltr"><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><p><b>Butler SQL</b> is a now-defunct <a href="SQL" title="SQL">SQL</a>-based <a href="Database_server" title="Database server">database server</a> for the <a href="Classic_Mac_OS" title="Classic Mac OS">classic Mac OS</a> released by Canadian developer EveryWare Development in 1992.<sup id="cite_ref-1" class="reference"><a href="#cite_note-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup> For much of its history, it was partnered with another EveryWare product, Tango (released 1995),<sup id="cite_ref-2" class="reference"><a href="#cite_note-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> that built dynamic database pages from SQL data. Butler SQL ceased development when <a href="Pervasive_Software" title="Pervasive Software">Pervasive Software</a> acquired EveryWare in 1998;<sup id="cite_ref-3" class="reference"><a href="#cite_note-3"><span class="cite-bracket">[</span>3<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-4" class="reference"><a href="#cite_note-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup> Tango was sold by Pervasive to Australian firm Witango Technologies in 2001 and renamed to Witango,<sup id="cite_ref-5" class="reference"><a href="#cite_note-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> then subsequently acquired by Tronics Software in 2010 and renamed to TeraScript.<sup id="cite_ref-6" class="reference"><a href="#cite_note-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup>
</p><p>Butler was introduced to take advantage of new a Mac OS component known as the <a href="Data_Access_Manager" title="Data Access Manager">Data Access Manager</a> (DAM), which was similar in concept to <a href="ODBC" class="mw-redirect" title="ODBC">ODBC</a>, allowing end-user client programs to access various data sources. DAM, however, worked at a lower level than ODBC and did not contain any inherent query language. To address the concern that a single DAM program might want to work with different back-end databases, Apple used a second system known as the <a href="Data_Access_Language" title="Data Access Language">Data Access Language</a> (DAL), which was a variant of SQL that included additional flow-control and data manipulation instructions. DAL queries were converted to the target database using an adaptor on the server.
</p><p>Butler was written to natively support DAL as its variant of SQL, and use DAM internally to support networking. As such, it avoided several intermediary layers that would be required to use the same queries on other database servers. Butler 2.0, released in May 1996, added direct <a href="ODBC" class="mw-redirect" title="ODBC">ODBC</a> links as well.
</p><p>Butler suffered from performance problems due to the single-user nature of the Mac OS. In particular, file access was single-threaded and multitasking was coordinated by the applications, not the operating system.
</p>
<div class="mw-heading mw-heading2"><h2 id="Reception">Reception</h2></div>
<p>A 1996 <i><a href="Macworld" title="Macworld">Macworld</a></i> review of web-publishing tools highlighted Butler SQL as the only Web-enabled SQL database available for Macintosh. The review called the Butler-Tango suite useful for small databases but "cumbersome for building and managing large databases containing many tables, largely due to the tools' inability to display relationships between tables graphically."<sup id="cite_ref-7" class="reference"><a href="#cite_note-7"><span class="cite-bracket">[</span>7<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading2"><h2 id="Further_reading">Further reading</h2></div>
<ul><li>Lawrence Charters, <a rel="nofollow" class="external text" href="http://www.wap.org/meetings/GM0196.html">"Data, Data EveryWare"</a>, <i>January 1996 General Meeting</i>, Washington Apple Pi</li>
<li><a rel="nofollow" class="external text" href="http://www.allbusiness.com/technology/software-services-applications-network-software/7229096-1.html">"EveryWare ships Butler SQL 2.0"</a>, <i>Business Wire</i>, 13 May 1996</li></ul>
<div class="mw-heading mw-heading2"><h2 id="References">References</h2></div>
<style data-mw-deduplicate="TemplateStyles:r1239543626">
/* start https://en.wikipedia.org/ */
.mw-parser-output .reflist{margin-bottom:0.5em;list-style-type:decimal}@media screen{.mw-parser-output .reflist{font-size:90%}}.mw-parser-output .reflist .references{font-size:100%;margin-bottom:0;list-style-type:inherit}.mw-parser-output .reflist-columns-2{column-width:30em}.mw-parser-output .reflist-columns-3{column-width:25em}.mw-parser-output .reflist-columns{margin-top:0.3em}.mw-parser-output .reflist-columns ol{margin-top:0}.mw-parser-output .reflist-columns li{page-break-inside:avoid;break-inside:avoid-column}.mw-parser-output .reflist-upper-alpha{list-style-type:upper-alpha}.mw-parser-output .reflist-upper-roman{list-style-type:upper-roman}.mw-parser-output .reflist-lower-alpha{list-style-type:lower-alpha}.mw-parser-output .reflist-lower-greek{list-style-type:lower-greek}.mw-parser-output .reflist-lower-roman{list-style-type:lower-roman}
/* end https://en.wikipedia.org/ */
</style><div class="reflist">
<div class="mw-references-wrap"><ol class="references">
<li id="cite_note-1"><span class="mw-cite-backlink"><b><a href="#cite_ref-1">^</a></b></span> <span class="reference-text"><style data-mw-deduplicate="TemplateStyles:r1238218222">
/* start https://en.wikipedia.org/ */
.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("./mw/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("./mw/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("./mw/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("./mw/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}
/* end https://en.wikipedia.org/ */
</style><cite id="CITEREFWylie1991" class="citation magazine cs1">Wylie, Margie (17 December 1991). "EveryWare SQL server built for DAM". <i><a href="MacWeek" class="mw-redirect" title="MacWeek">MacWeek</a></i>.</cite></span>
</li>
<li id="cite_note-2"><span class="mw-cite-backlink"><b><a href="#cite_ref-2">^</a></b></span> <span class="reference-text"><cite id="CITEREFEngst1995" class="citation web cs1">Engst, Adam (18 December 1995). <a rel="nofollow" class="external text" href="https://tidbits.com/1995/12/18/it-takes-two-to-tango/">"It Takes Two to Tango"</a>. <a href="Tidbits" title="Tidbits">Tidbits</a>.</cite></span>
</li>
<li id="cite_note-3"><span class="mw-cite-backlink"><b><a href="#cite_ref-3">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://www.mactech.com/1998/10/01/npl-pervasive-to-acquire-everyware-development/">"EveryWare Development to be acquired by Pervasive Software"</a>. <a href="MacTech" title="MacTech">MacTech</a>. 1 October 1998.</cite></span>
</li>
<li id="cite_note-4"><span class="mw-cite-backlink"><b><a href="#cite_ref-4">^</a></b></span> <span class="reference-text"><cite id="CITEREFDuncan2001" class="citation web cs1">Duncan, Geoff (31 October 2001). <a rel="nofollow" class="external text" href="https://www.macworld.com/article/151938/panorama-2.html">"Panorama 4.0"</a>.</cite></span>
</li>
<li id="cite_note-5"><span class="mw-cite-backlink"><b><a href="#cite_ref-5">^</a></b></span> <span class="reference-text"><cite class="citation news cs1"><a rel="nofollow" class="external text" href="https://www.smh.com.au/technology/two-to-witango-and-take-on-the-world-20020813-gdfj76.html">"Two to Witango - and take on the world"</a>. <a href="The_Sydney_Morning_Herald" title="The Sydney Morning Herald">The Sydney Morning Herald</a>. 13 August 2002.</cite></span>
</li>
<li id="cite_note-6"><span class="mw-cite-backlink"><b><a href="#cite_ref-6">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://www.terascript.com/">"Recent Announcements"</a>. Tronics Software LLC. 2024.</cite></span>
</li>
<li id="cite_note-7"><span class="mw-cite-backlink"><b><a href="#cite_ref-7">^</a></b></span> <span class="reference-text"><cite id="CITEREFBeckman1996" class="citation magazine cs1">Beckman, Mel (October 1996). "Energize Your Website". <i><a href="Macworld" title="Macworld">Macworld</a></i>. Vol. 13, no. 10. IDG. p. 108.</cite></span>
</li>
</ol></div></div></div><!--htdig_noindex--><div><div class="zim-footer">
This article is issued from <a class="external text" title="Last edited on 2025-02-07" href="https://en.wikipedia.org/wiki/?title=Butler_SQL&oldid=1274425527">Wikipedia</a>. The text is available under <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-Share Alike 4.0</a> unless otherwise noted. Additional terms may apply for the media files.
</div>
</div><!--/htdig_noindex--></div>
</div>
</main>
</div>
</div>
</div>
</body></html>